UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MNa0tf7fgK9O5qtP6RAe+BrQhW5Wbf1sITEoQQNt2+k='
WHERE
key_id = 'e959e173f7a7e990958fd6205bee422b131a517739e6ad1a78e15502d09a59e3'
AND (
token = 'MNa0tf7fgK9O5qtP6RAe+BrQhW5Wbf1sITEoQQNt2+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)