UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4K5v5mv4CYAE9l0odYfmoX6G1YsAgsVK2ePVcyIcYRs='
WHERE
key_id = '9d14cff91002c9f46391abf9862d884511ca0ee4b17ab575f8eecd9949550269'
AND (
token = '4K5v5mv4CYAE9l0odYfmoX6G1YsAgsVK2ePVcyIcYRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)