UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpFrVh48y3u3qD5G4o4RFyTG8r08Opi5oUAUVGN9VYw='
WHERE
key_id = '29247290150897d0f39ab565d1dbd7fabdf6358782da38199d2b872dbdb57a6c'
AND (
token = 'qpFrVh48y3u3qD5G4o4RFyTG8r08Opi5oUAUVGN9VYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)