UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Kv3kjkts8EPv0oZxF827NBzfO67iABUPuthfMcQJPs='
WHERE
key_id = '5f587c44fc8d80eda2783e47acec7226f15f973924f7c1f6d5cba2effa4b7717'
AND (
token = '3Kv3kjkts8EPv0oZxF827NBzfO67iABUPuthfMcQJPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)