UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3DQQRtIqwxxfdpW25Ag31vG8+F4E3pdnqYNPi05qv4='
WHERE
key_id = 'bd191b148f892175f1cb715aa0d0d7352f44213e808df609297986cde9ec4e50'
AND (
token = 'a3DQQRtIqwxxfdpW25Ag31vG8+F4E3pdnqYNPi05qv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)