UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yccs1ILn4DocsgTktUO/uwsNolR/3igGFfnbl92EmNY='
WHERE
key_id = 'a1e677acc74ed0ec026d260ae6c684ef11698ed38af4dcfeaa6a4964c0b3fe06'
AND (
token = 'Yccs1ILn4DocsgTktUO/uwsNolR/3igGFfnbl92EmNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)