UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvfdKKdLGfNtOn75Uyo2JBOoFgFLRi2pk/FSZVL3/SI='
WHERE
key_id = '00309a9f28a63c7771b18c27de879ec90117d841c25463bfb3bfc9abdba528a0'
AND (
token = 'zvfdKKdLGfNtOn75Uyo2JBOoFgFLRi2pk/FSZVL3/SI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)