UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/MMxt5F+fpY4DmJ2vIbH+MiOPEi/3Cd/Yra07RlADLE='
WHERE
key_id = 'c08f7030032d0a188aa5d429004b44cb16b597a756738c9c2edc2fcb899673f5'
AND (
token = '/MMxt5F+fpY4DmJ2vIbH+MiOPEi/3Cd/Yra07RlADLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)