UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AAjG7AJbtMvJMGWiaRFsYqL3DgFknZHVk7PK5W124c='
WHERE
key_id = 'd5d61a31f7ca97544c9155990bbb2ad2c418fb217a4a833002f5cb630664ecc1'
AND (
token = '6AAjG7AJbtMvJMGWiaRFsYqL3DgFknZHVk7PK5W124c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)