UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khB/JVyJTzJV9QjYwg8eLWusq4aCoE5/xttjNVolHAo='
WHERE
key_id = 'c59f1a3368b0acaa89ea3afa2614b387bef3c67e6d53d9838f5581005430001e'
AND (
token = 'khB/JVyJTzJV9QjYwg8eLWusq4aCoE5/xttjNVolHAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)