UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0qS9gB8EZaLf+GmOS74tcn70cCFP5k9KSF3KQGfDPY='
WHERE
key_id = 'adfa968242a9d4c087d21613e9e51bce983389e96580148c99eaafa86e8c13af'
AND (
token = 'p0qS9gB8EZaLf+GmOS74tcn70cCFP5k9KSF3KQGfDPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)