UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bBGf8/RdEYUUC9/dmx0tbSNvnCGxixEOtZcetOaDvgg='
WHERE
key_id = 'ac4b6b49013ad536b1b902488ed7c62c01f6175b284070391ca2182d6a5b7400'
AND (
token = 'bBGf8/RdEYUUC9/dmx0tbSNvnCGxixEOtZcetOaDvgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)