UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fcO0E71HF97ODnW+5rvmfO+Rm04dpV7iDkTZn/P1UU='
WHERE
key_id = 'c9a95ac46eb4271dee0861e018a2098d4495bffeee3255b7a34bef9b38fbb217'
AND (
token = '1fcO0E71HF97ODnW+5rvmfO+Rm04dpV7iDkTZn/P1UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)