UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQ1t9kH1OzBfepLJeIHZFTTuH7ayvOeIA2E17TWwcOM='
WHERE
key_id = '2ba28568c1cff81574cf02994b7d7e23c77205b7e49dbd05422b7b66a9417813'
AND (
token = 'HQ1t9kH1OzBfepLJeIHZFTTuH7ayvOeIA2E17TWwcOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)