UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Oy6CaD0w218u6Gu0HYj9cuBqvspNBtkl0wWcf6Sdpw='
WHERE
key_id = 'deaad6091a2130dd9a2aee872d6c474e369d1caef1a049ce62315d559d537813'
AND (
token = '8Oy6CaD0w218u6Gu0HYj9cuBqvspNBtkl0wWcf6Sdpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)