UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7JxrGhPNF1ljaznoc45HMh3qOeCVmeZjmwzA8wnMCg='
WHERE
key_id = '19777220779435496299b2d8baa7a02b24b2e41798922fd16a8b4ca975a56f32'
AND (
token = 'N7JxrGhPNF1ljaznoc45HMh3qOeCVmeZjmwzA8wnMCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)