SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '69051a796fde8fcf0364cf6c370ab07c15489da53d40bde0a531660f5aa6de10' 
  AND token = 'LJ/Fgl+SNW3N7RfiVp8CwsfiN3LD1jhRjQD5+al723Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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