UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zm6npz3gF9PMiyCCJT8658flD54iAT+kPKyvVZjcRIE='
WHERE
key_id = '6c535325521c758578d7309c0ddaa00a92fbdb4b28531a021a7cc5447a9d1b03'
AND (
token = 'Zm6npz3gF9PMiyCCJT8658flD54iAT+kPKyvVZjcRIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)