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