SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c50a5d70ccfc9aa73111981d5e7b0de8f2964ee7feda6c880e6d7dfd5b14dc36' 
  AND token = 'GbtUkS+gIQ7PAluKhL4MwNns0HiMV4gqCHc1pz86eeg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00050

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}