UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2pUbA2mfQxoeB3mLiFphqi72Akqdo+C9odO2okHscqU='
WHERE
key_id = 'c7f793bf64efbbdcfc0c489cb56cbac8da45e0bbe35139d710e7bfdfeedccafd'
AND (
token = '2pUbA2mfQxoeB3mLiFphqi72Akqdo+C9odO2okHscqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)