UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fPMYUxFXEXdd9MA3X9Enssy0gpJP5nKnPC6lv0i8gL0='
WHERE
key_id = 'e87ce048b143ba24c723d6cdd05f246e18a6eb7b6be2991e715fa9d1154b26ea'
AND (
token = 'fPMYUxFXEXdd9MA3X9Enssy0gpJP5nKnPC6lv0i8gL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)