UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ri01G8p96WONlPb7p/y/eW0qjUMYfvCmvMoAn8w6f/0='
WHERE
key_id = 'd1c5375c272f6271fa3b420d0c5f5597f5250c75745fcb1e79f225a55a9d761a'
AND (
token = 'ri01G8p96WONlPb7p/y/eW0qjUMYfvCmvMoAn8w6f/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)