SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bb2af72d4bc8b7d0ea9b4971e6e2ee26556b669d8f2fec038126be310183b472' 
  AND token = 'gT1j49EvcxjhHHcZ2VKXVJaHQfSDsMNT+AHT5Sj9eOw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

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