UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g0uWmBWRIfeJnDqhS228iCKoeVG6qNOZ51Irm66LQCA='
WHERE
key_id = 'b7bc9cd730498d0b7342f42964ba7e6ad592ea829d2dce831a2b434dea57fe5b'
AND (
token = 'g0uWmBWRIfeJnDqhS228iCKoeVG6qNOZ51Irm66LQCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)