UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4amyIS+J7La4weOiDC05f89bNIgPYafiGZIDaCA0afY='
WHERE
key_id = '0a78757d590b4eb282d4b2fc151bdfeea5412534d937bdf9abb9087298ab7a35'
AND (
token = '4amyIS+J7La4weOiDC05f89bNIgPYafiGZIDaCA0afY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)