SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e682c1a8ec2e8f307179164059cf5f6e44df6f6928905cd54b5d2a6fb2d5abd5' 
  AND token = '/AkpgKZ0z485uhzUXlroJSg2YvUC8b7vtO4kvi3WOc4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}