UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I3ugNwj75vbTzM0vk0RHPciGcmrmMyHtVbkuo5bnug0='
WHERE
key_id = '54c1a35ad4856978ddaf36058a151ceef39e91bbbf6f32ffe91557ad3cb99bcb'
AND (
token = 'I3ugNwj75vbTzM0vk0RHPciGcmrmMyHtVbkuo5bnug0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)