UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BDd6ZJxYJmqEhSCvd82cSR44Cz0yqoYxzKvd6OqtPuU='
WHERE
key_id = 'a08160f4e39495d2a45664dff841399ec16dcfb468c11a2334e0c99555785834'
AND (
token = 'BDd6ZJxYJmqEhSCvd82cSR44Cz0yqoYxzKvd6OqtPuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)