UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8CggBAggtiqPMl5fCu+uYSR0AN4uW2IlNWapBpgF4c='
WHERE
key_id = 'ca8f76883cd48ed235f5fe20c61833af6e144b042656c2f171bde204dcd1b8bf'
AND (
token = 'Y8CggBAggtiqPMl5fCu+uYSR0AN4uW2IlNWapBpgF4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)