UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7IBWhrS55yJrET5BzgUB1BLU9BDJwtcv9Wb+8xakKvY='
WHERE
key_id = '6ff55246bff674a7358af97432d09a865e85d47324b7acb2ca7bdc55911a6efd'
AND (
token = '7IBWhrS55yJrET5BzgUB1BLU9BDJwtcv9Wb+8xakKvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)