UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mQLIBGKQEEW+H9UC69nw/GIddf0xdYW3cgnjN9mBw1U='
WHERE
key_id = '9e754b1b89a63cd4b83436ea48e6654efe398e9a4eef35fb3eae5c9ed052b2ed'
AND (
token = 'mQLIBGKQEEW+H9UC69nw/GIddf0xdYW3cgnjN9mBw1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)