SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '18307d6ff5597c11ffe68d3475bbf081cd4b230e4feaf9d3a3d95a00eb1fa5d8' 
  AND token = 'X13RW5XC6poQ2siLNv/IBb/C9j75aK2kRtrICB35qT8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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