SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'dede0711fb963dcb538b51945ad65a2eb2ae900ea05f9d85c56b5b3703b5add3' 
  AND token = '5cPF2lQpqVdLRTzaq8Yxd7kTvHOd7FTZ4zxaH4C2F4E=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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