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